Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerOrderGroupID (PK) | A unique system assigned identifier for the group of line items from a Customer placed order, recording how the Customer wishes the StockItems that have been orderd are to be given to the Customer. | ID_CTORD_GRP | Identity | integer | |
Inventory (FK) | A unique system assigned identifier for the InventoryLocation from which the Items in this CustomerOrderProductGroup being ordered are to be sourced. | Inventory | Identity | integer | InventoryLocation(LO_LCN_INV) |
CustomerOrderProductGroupTypeCode (FK) | A retailer assigned code denoting the different kinds of CustomerOrderProductGroups. Possible values include: FulfillmentGroup, SourceGroup, GiftWrapGroup etc... | CD_TYP_CTORD_GRP | Code2 | char(2) | CustomerOrderProductGroupType(CO_TYP_CTORD_GRP) |
SupplierID (FK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | Supplier(PA_SPR) |